CREATE TABLE Products
(
	[ProductID] INT NOT NULL PRIMARY KEY IDENTITY,
	[Name] NVARCHAR(100) NOT NULL,
	[Description] NVARCHAR(500) NOT NULL,
	[Category] NVARCHAR(50) NOT NULL,
	[Price] DECIMAL(16, 2) NOT NULL
)
go

insert into Products(Name,Description,Category,Price) values('Kayak','A boat for one person','Watersports',275.00);
insert into Products(Name,Description,Category,Price) values('Lifejacket','Protective and fashionable','Watersports',48.95);
insert into Products(Name,Description,Category,Price) values('Soccer Ball','FIFA-approved size and weight','Soccer',19.50);
insert into Products(Name,Description,Category,Price) values('Corner Flags','Give your playing field a professional touch','Soccer',34.95);
insert into Products(Name,Description,Category,Price) values('Stadium','Flat-packed, 35,000-seat stadium','Soccer',79500.00);
insert into Products(Name,Description,Category,Price) values('Thinking Cap','Improve your brain efficiency by 75%','Chess',16.00);
insert into Products(Name,Description,Category,Price) values('Unsteady Chair','Secretly give your opponent a disadvantage','Chess',29.95);
insert into Products(Name,Description,Category,Price) values('Human Chess Board','Human Chess Board','Chess',75.00);
insert into Products(Name,Description,Category,Price) values('Bling-Bling King','Gold-plated, diamond-studded King','Chess',1200.00);
go

ALTER TABLE [dbo].[Products]
ADD [ImageData] VARBINARY (MAX) NULL,
[ImageMimeType] VARCHAR (50) NULL;
go

















